INSERT INTO onetest ( UdstrCd,UdstrDescCn,UdstrDescEn,Email, Address,ZipCd,PhoneNo,FaxNo,Udstr_Remark1,
Udstr_Remark2,Udstr_Remark3,Udstr_Remark4,Director,DirectorNo,DirectorMobile,DirectorEmail,FinanceContact,
FinanceContactNo,FinanceContactMobile,FinanceEmail,CompanyCd,PaymentBy,SimsCd,UdstrTypeName,CreditLvlName,
ProvinceName,CityName,CoopTypeName,Dstr_CD,Dstr_Desc_CN,Dstr_Desc_EN,Email1,Email2,Zip_CD,Dstr_PhoneNo,
Dstr_FaxNo,Dstr_Remark1,Dstr_Remark2,Dstr_Remark3,Dstr_Remark4,CoopStatus,Dstr_Director,Dstr_Director_NO,
Dstr_Director_Mobile,Dstr_Finance_Contact,Dstr_Finance_Contact_NO,Dstr_Finance_Contact_Mobile,Fd_Operator,
Fd_OperatorNO,Upload_DT,Franchise,BU,Dstr_Coop_Start_DT,Dstr_Coop_End_DT,Dstr_Coop_Status_CD,Parent_Dstr_CD,
Parent_Dstr_Desc_CN,Biz_Contact,Biz_Contact_NO,Biz_Contact_Mobile,Company_CD,CURRENCY_ID,SAP_CD,Payment_By,
DstrTypeName,DstrCoopTypeName,FdSoftwareName,FdStatuseName,DstrCoopStatusName,DstrDstrLvlName,DstrDstrClassName,
DstrCreditLvlName,DstrProvinceName,DstrCityName,CurrencyName,iChannel_Email,iChannel_Mobile,iChannel_Contact,
iChannel_Contact_No,BusinessContact,BusinessNo,BusinessMobile,BusinessEmail,DataContact,DataNo,DataMobile,
DataEmail,Contractor,ContractorNo,ContractorMobile,ContractorEmail,DD_Date,DD_DATE_END,DD_Status,DD_DATE_D2,
DD_DATE_END_D2,DD_STATUS_D2,DD_DATE_SERVICE,DD_DATE_END_SERVICE,DD_STATUS_SERVICE,UPDATE_DT,DSM_Email,
RSM_Email,BU_DSM_Email,BU_RSM_Email
			)
			VALUES
				(
'${UdstrCd}',
'${UdstrDescCn}',
'${UdstrDescEn}',
'${Email}',
'${Address}',
'${ZipCd}',
'${PhoneNo}',
'${FaxNo}',
'${Udstr_Remark1}',
'${Udstr_Remark2}',
'${Udstr_Remark3}',
'${Udstr_Remark4}',
'${Director}',
'${DirectorNo}',
'${DirectorMobile}',
'${DirectorEmail}',
'${FinanceContact}',
'${FinanceContactNo}',
'${FinanceContactMobile}',
'${FinanceEmail}',
'${CompanyCd}',
'${PaymentBy}',
'${SimsCd}',
'${UdstrTypeName}',
'${CreditLvlName}',
'${ProvinceName}',
'${CityName}',
'${CoopTypeName}',
'${Dstr_CD}',
'${Dstr_Desc_CN}',
'${Dstr_Desc_EN}',
'${Email1}',
'${Email2}',
'${Zip_CD}',
'${Dstr_PhoneNo}',
'${Dstr_FaxNo}',
'${Dstr_Remark1}',
'${Dstr_Remark2}',
'${Dstr_Remark3}',
'${Dstr_Remark4}',
'${CoopStatus}',
'${Dstr_Director}',
'${Dstr_Director_NO}',
'${Dstr_Director_Mobile}',	
'${Dstr_Finance_Contact}',
'${Dstr_Finance_Contact_NO}',
'${Dstr_Finance_Contact_Mobile}',
'${Fd_Operator}',
'${Fd_OperatorNO}',
'${Upload_DT}',
'${Franchise}',
'${BU}',
'${Dstr_Coop_Start_DT}',
'${Dstr_Coop_End_DT}',
'${Dstr_Coop_Status_CD}',
'${Parent_Dstr_CD}',
'${Parent_Dstr_Desc_CN}',
'${Biz_Contact}',
'${Biz_Contact_NO}',
'${Biz_Contact_Mobile}',
'${Company_CD}',
'${CURRENCY_ID}',
'${SAP_CD}',
'${Payment_By}',
'${DstrTypeName}',
'${DstrCoopTypeName}',
'${FdSoftwareName}',
'${FdStatuseName}',
'${DstrCoopStatusName}',
'${DstrDstrLvlName}',
'${DstrDstrClassName}',
'${DstrCreditLvlName}',
'${DstrProvinceName}',
'${DstrCityName}',
'${CurrencyName}',
'${iChannel_Email}',
'${iChannel_Mobile}',
'${iChannel_Contact}',
'${iChannel_Contact_No}',
'${BusinessContact}',
'${BusinessNo}',
'${BusinessMobile}',
'${BusinessEmail}',
'${DataContact}',
'${DataNo}',
'${DataMobile}',
'${DataEmail}',
'${Contractor}',
'${ContractorNo}',
'${ContractorMobile}',
'${ContractorEmail}',
'${DD_Date}',
'${DD_DATE_END}',
'${DD_Status}',
'${DD_DATE_D2}',
'${DD_DATE_END_D2}',	
'${DD_STATUS_D2}',
'${DD_DATE_SERVICE}',
'${DD_DATE_END_SERVICE}',
'${DD_STATUS_SERVICE}',
'${UPDATE_DT}',
'${DSM_Email}',
'${RSM_Email}',
'${BU_DSM_Email}',
'${BU_RSM_Email}'
				)